drop proc spa_SEC_CreateForgotPwdRequest
go
/*********************************************************************************************            
* PROCEDURE: spa_SEC_CreateForgotPwdRequest            
* PURPOSE: Create a new user from FE website            
* NOTES:            
* CREATED: Nha Doan 5/01/2011           
* MODIFIED:             
*/            
/*'-------------------------------------------------------------------------------------------------*            
' Date       | Version | Ticket #    |       Author             | Description            
' ========== | ======= | =========== | =========================| ====================================================================            
' 5/01/2011  |  1.00   | 00000       | Nha Doan                 | CREATED NEW.
'-------------------------------------------------------------------------------------------------*            
*/
/*
Ex:
[spa_SEC_CreateForgotPwdRequest]            
	 @UserRecId = '{21CAFCEA-8629-4FA9-9DC0-85A98AD344D2}',            
	 @ValidKey ='6E-9B-3A-76-20-AA-F7-7F-36-27-75-15-09-77-EE-B8'    
*/            
create proc [spa_SEC_CreateForgotPwdRequest]            
 @UserRecId uniqueidentifier,            
 @ValidKey varchar(100) 
as            
            
update SEC_Users
set     
 UserPasswordTmp = @ValidKey,
 UserPasswordDTS = getdate()
where 
 RecId = @UserRecId 
GO